﻿CREATE TABLE [dbo].[Store_PropertyValue] (
    [Id]                INT            IDENTITY (1, 1) NOT NULL,
    [Store_Property_Id] INT            NOT NULL,
    [Value]             NVARCHAR (256) NOT NULL,
    [SortOrder]         INT            NOT NULL,
    [IsUseInFilter]     BIT            NOT NULL,
    CONSTRAINT [PK_Store_PropertyValue] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Store_PropertyValue_Store_Property] FOREIGN KEY ([Store_Property_Id]) REFERENCES [dbo].[Store_Property] ([Id]) ON DELETE CASCADE ON UPDATE CASCADE
);

